Lesson: 14 - Basic operations in Spreadsheets

Purpose: Students learn formulae and basic operations in spreadsheets.

No. of. Classes

One class - One hour.

Materials Required

Desktop computer or Laptop & Open office.

Curriculum Content 7.4)Basic operations.
Prior knowledge

Students should know the concepts of four operations.


Students should know how to work in spreadsheets.

Exercises

Exercise:1

1. Adding, Subtracting, Multiplying and Dividing using spreadsheet operators.


Exercise:2

2. Create a new spreadsheet and name it as ‘student mark sheet.ods’.
Use formulae to calculate Total, Average and Pass / Fail result.


Use this excel sheet to show the errors when you try to do some calculations.


Solutions


  • Link to view the Solution Video for Exercise-1 (Solution).
  • Link to view the OpenOffice Solution Spreadsheets for Exercise-2 (Solution).

    • Teacher's Instructions
    1. Teachers should explain the importance of formulae in Spreadsheets.
    2. Teachers should ensure that the students understand simple operations like Addition, Subtraction, Multiplication, and Division.
    3. The students should know & the usage of the formula bar that is placed at the top left of the sheet.
    4. Show what errors we get when we do formulas either with empty cells or with invalid types. i.e. adding a non-number.